[dbo].[BAEOrderCategoryParentLookupLoad]

SQLServer > iMIS1521GA > Stored Procedures > dbo.BAEOrderCategoryParentLookupLoad

Properties
Parameters
SQL Script
Uses

Property	Value
ANSI Nulls On
Quoted Identifier On

Parameters

Name	Data Type	Max Length (Bytes)
@OrderCategoryID	int	4
@OrderCategoryParentID	int	4

SQL Script

create procedure [dbo].[BAEOrderCategoryParentLookupLoad] @OrderCategoryID as
int,
    @OrderCategoryParentID AS int
AS
    SELECT *
    FROM OrderCategoryParentLookup
    WHERE OrderCategoryID = @OrderCategoryID AND
    OrderCategoryParentID = @OrderCategoryParentID;

GO

Uses

[dbo].[OrderCategoryParentLookup]
dbo